import pandas as pd  
from openpyxl import Workbook  
import re  

# 读取Excel文件  
df = pd.read_excel('agent.xlsx')  

grouped = df.groupby('customerId')['agentCustomerId'].nunique()  

multiple_agent_customers = grouped[grouped > 1].index.tolist()  

print(multiple_agent_customers)
